SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='T'
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to easy Upper Valley living at 299 Mount Support Road, Unit 21 in Lebanon. Ideally located just minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, downtown Hanover, and shopping, this well-maintained two-bedroom, two and one-half-bath townhouse offers the perfect combination of comfort, convenience, and low-maintenance living. Built in 2004 and featuring 1,442 square feet of living space, the home offers a bright and functional floor plan with spacious living and dining areas, abundant natural light, and attractive wood flooring throughout the main level. The kitchen features ample cabinet and counter space, a center island, and an efficient layout perfect for everyday living and entertaining. Upstairs, you'll find a generously sized primary suite with private bath, a second bedroom, a dedicated home office space ideal for remote work, and the convenience of second-floor laundry. Large windows throughout the home create a bright and welcoming atmosphere. Enjoy outdoor relaxation on your private patio while taking advantage of the community's 20 acres of shared land, walking trails, and pet-friendly environment. The attached one-car garage provides convenience and additional storage. The association handles landscaping, snow removal, and trash service, allowing you to spend more time enjoying everything the Upper Valley has to offer. Connected to town water and sewer and situated in one of Lebanon's most convenient locations, this move-in-ready townhouse is an exceptional opportunity for professionals, Dartmouth Health employees, Dartmouth College faculty, and anyone seeking a low-maintenance lifestyle close to work, recreation, and amenities. Join me on Sunday, the 19th, for an Open House from 12:00 until 2:00 to preview this Lebanon condominium in this great location!
Description:Showings begin with an open house on Saturday, April 4, 11am-1pm. This Gile Hill end unit condo welcomes you to its modern, light-filled interior via a no-step entrance ramp right from your covered parking spot. Enjoy easy, one-level living in an energy-efficient LEED certified building. The open floor plan living area incorporates a kitchen with newer stainless steel appliances and granite countertops, a dining area, and large living/office space with a mini split to keep you cool in summer months. Just off the living room, a covered deck is the perfect place for your morning coffee. The hallway leads to a bedroom with full bath across the hall, and the primary suite with its own newly-renovated bathroom and walk-in closet. Located half a mile from the DHMC campus and 2 miles from downtown Hanover with its shops and restaurants, this location is hard to beat. Enjoy access to multiple hiking trails right from the property and countless other outdoor activities and cultural opportunities just outside your door!